www.gusucode.com > VC++ 酒店管理系统-源码程序 > VC++ 酒店管理系统-源码程序/code/hotel2003/InfoSet.cpp

    //Download by http://www.NewXing.com
// InfoSet.cpp : implementation file
//

#include "stdafx.h"
#include "qq.h"
#include "InfoSet.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CGuestInfoSet

IMPLEMENT_DYNAMIC(CGuestInfoSet, CRecordset)

CGuestInfoSet::CGuestInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CGuestInfoSet)
	m_HandCode = _T("");
	m_Name = _T("");
	m_GuestType = _T("");
	m_Sex = _T("");
	m_Certificate = _T("");
	m_CertifyCode = _T("");
//	m_StartTime=_T("");
	m_IsMember = FALSE;
	m_IsMaster = FALSE;
	m_GroupID = _T("");
	m_GuestNum = 0;
	m_RoomNum = _T("");
	m_RoomCode = _T("");
	m_nFields = 12;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CGuestInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CGuestInfoSet::GetDefaultSQL()
{
	return _T("[GuestInfo]");
}

void CGuestInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CGuestInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[HandCode]"), m_HandCode);
	RFX_Text(pFX, _T("[Name]"), m_Name);
	RFX_Text(pFX, _T("[GuestType]"), m_GuestType);
	RFX_Text(pFX, _T("[Sex]"), m_Sex);
	RFX_Text(pFX, _T("[Certificate]"), m_Certificate);
	RFX_Text(pFX, _T("[CertifyCode]"), m_CertifyCode);
	RFX_Bool(pFX, _T("[IsMember]"), m_IsMember);
	RFX_Bool(pFX, _T("[IsMaster]"), m_IsMaster);
	RFX_Text(pFX, _T("[GroupID]"), m_GroupID);
	RFX_Long(pFX, _T("[GuestNum]"), m_GuestNum);
	RFX_Text(pFX, _T("[RoomNum]"), m_RoomNum);
	RFX_Text(pFX, _T("[RoomCode]"), m_RoomCode);
//	RFX_Text(pFX, _T("[StartTime]"),m_StartTime);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CGuestInfoSet diagnostics

#ifdef _DEBUG
void CGuestInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CGuestInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CRoomInfoSet

IMPLEMENT_DYNAMIC(CRoomInfoSet, CRecordset)

CRoomInfoSet::CRoomInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CRoomInfoSet)
	m_RoomCode = _T("");
	m_RoomType = _T("");
	m_Floor = 0;
	m_Phone = _T("");
	m_RoomStatus = _T("");
	m_PriceType = FALSE;
	m_Price = 0.0f;
	m_nFields = 7;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CRoomInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CRoomInfoSet::GetDefaultSQL()
{
	return _T("[RoomInfo]");
}

void CRoomInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CRoomInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[RoomCode]"), m_RoomCode);
	RFX_Text(pFX, _T("[RoomType]"), m_RoomType);
	RFX_Int(pFX, _T("[Floor]"), m_Floor);
	RFX_Text(pFX, _T("[Phone]"), m_Phone);
	RFX_Text(pFX, _T("[RoomStatus]"), m_RoomStatus);
	RFX_Bool(pFX, _T("[PriceType]"), m_PriceType);
	RFX_Single(pFX, _T("[Price]"), m_Price);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CRoomInfoSet diagnostics

#ifdef _DEBUG
void CRoomInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CRoomInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG

//////////////////////////////////////////////////////////////////////
// CCreateBillCode Class
//////////////////////////////////////////////////////////////////////

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
//int CCreateBillCode::m_BillNum=0;
CCreateBillCode::CCreateBillCode()
{ 
//	m_BillNum++;
}

CCreateBillCode::~CCreateBillCode()
{

}

CString CCreateBillCode::GenereBillCode()
{//产生帐单号码
	long n=0;
   CBillInfoSet m_BillInfoSet;
   if(!m_BillInfoSet.Open())
   {
	   AfxMessageBox("打开数据库失败!");
	   return CString("");
   }
//   long n=m_BillInfoSet.GetRecordCount();
//不要调用GetRecordCount()函数会得到错误的结果
   m_BillInfoSet.MoveFirst();//移动到第一条记录
   while (!m_BillInfoSet.IsEOF()) 
   {
	   n++;
	   m_BillInfoSet.MoveNext();//移动到下一条记录
   }
   m_BillInfoSet.Close(); //关闭数据库 
   CTime time=CTime::GetCurrentTime();
   CString str=time.Format("%H%M");
   CString strBillCode;
   strBillCode.Format("%ld",n+1);
   strBillCode="B"+str+strBillCode;
   return strBillCode;
}
CString CCreateBillCode::GenereBillCodeForCheckOut()
{//为结帐帐单产生帐单号码
	//产生帐单号码
	long n=0;
	CBillCheckoutInfoSet m_BillCheckoutInfoSet;
	if(!m_BillCheckoutInfoSet.Open())
	{
		AfxMessageBox("打开数据库失败!");
		return CString("");
	}
	//   long n=m_BillInfoSet.GetRecordCount();
	//不要调用GetRecordCount()函数会得到错误的结果
	m_BillCheckoutInfoSet.MoveFirst();//移动到第一条记录
	while (!m_BillCheckoutInfoSet.IsEOF()) 
	{
		n++;
		m_BillCheckoutInfoSet.MoveNext();//移动到下一条记录
	}
	m_BillCheckoutInfoSet.Close(); //关闭数据库 
	CTime time=CTime::GetCurrentTime();
	CString str=time.Format("%H%M%S");
	CString strBillCode;
	strBillCode.Format("%ld",n+1);
	strBillCode="B"+str+strBillCode;
	return strBillCode;
}
//////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
// CBillInfoSet

IMPLEMENT_DYNAMIC(CBillInfoSet, CRecordset)

CBillInfoSet::CBillInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBillInfoSet)
	m_BillCode = _T("");
	m_HandCode = _T("");
	m_Sum = 0;
	m_Paid = 0;
	m_Rebate = _T("");
	m_Striked = FALSE;
	m_nFields = 6;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CBillInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CBillInfoSet::GetDefaultSQL()
{
	return _T("[BillInfo]");
}

void CBillInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBillInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[BillCode]"), m_BillCode);
	RFX_Text(pFX, _T("[HandCode]"), m_HandCode);
	RFX_Long(pFX, _T("[Sum]"), m_Sum);
	RFX_Long(pFX, _T("[Paid]"), m_Paid);
	RFX_Text(pFX, _T("[Rebate]"), m_Rebate);
	RFX_Bool(pFX, _T("[Striked]"), m_Striked);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBillInfoSet diagnostics

#ifdef _DEBUG
void CBillInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CBillInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CServerInfoSet

IMPLEMENT_DYNAMIC(CServerInfoSet, CRecordset)

CServerInfoSet::CServerInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CServerInfoSet)
	m_ServerName = _T("");
	m_ServerPrice = 0.0f;
	m_nFields = 2;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CServerInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CServerInfoSet::GetDefaultSQL()
{
	return _T("[ServerInfo]");
}

void CServerInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CServerInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[ServerName]"), m_ServerName);
	RFX_Single(pFX, _T("[ServerPrice]"), m_ServerPrice);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CServerInfoSet diagnostics

#ifdef _DEBUG
void CServerInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CServerInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CFoodInfoSet

IMPLEMENT_DYNAMIC(CFoodInfoSet, CRecordset)

CFoodInfoSet::CFoodInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CFoodInfoSet)
	m_FoodName = _T("");
	m_FoodPrice = 0.0f;
	m_nFields = 2;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CFoodInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CFoodInfoSet::GetDefaultSQL()
{
	return _T("[FoodInfo]");
}

void CFoodInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CFoodInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[FoodName]"), m_FoodName);
	RFX_Single(pFX, _T("[FoodPrice]"), m_FoodPrice);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CFoodInfoSet diagnostics

#ifdef _DEBUG
void CFoodInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CFoodInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CEmployerInfoSet

IMPLEMENT_DYNAMIC(CEmployerInfoSet, CRecordset)

CEmployerInfoSet::CEmployerInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CEmployerInfoSet)
	m_EmployerCode = _T("");
	m_Name = _T("");
	m_Depart = _T("");
	m_nFields = 3;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CEmployerInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CEmployerInfoSet::GetDefaultSQL()
{
	return _T("[EmployerInfo]");
}

void CEmployerInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CEmployerInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[EmployerCode]"), m_EmployerCode);
	RFX_Text(pFX, _T("[Name]"), m_Name);
	RFX_Text(pFX, _T("[Depart]"), m_Depart);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CEmployerInfoSet diagnostics

#ifdef _DEBUG
void CEmployerInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CEmployerInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CBillContentInfoSet

IMPLEMENT_DYNAMIC(CBillContentInfoSet, CRecordset)

CBillContentInfoSet::CBillContentInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBillContentInfoSet)
	m_BillCode = _T("");
	m_BillContent = _T("");
	m_nFields = 2;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CBillContentInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CBillContentInfoSet::GetDefaultSQL()
{
	return _T("[BillContentInfo]");
}

void CBillContentInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBillContentInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[BillCode]"), m_BillCode);
	RFX_Text(pFX, _T("[BillContent]"), m_BillContent);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBillContentInfoSet diagnostics

#ifdef _DEBUG
void CBillContentInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CBillContentInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CBillCheckoutInfoSet

IMPLEMENT_DYNAMIC(CBillCheckoutInfoSet, CRecordset)

CBillCheckoutInfoSet::CBillCheckoutInfoSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBillCheckoutInfoSet)
	m_BillCode = _T("");
	m_HandCode = _T("");
	m_Sum = _T("");
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CBillCheckoutInfoSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CBillCheckoutInfoSet::GetDefaultSQL()
{
	return _T("[BillCheckoutInfo]");
}

void CBillCheckoutInfoSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBillCheckoutInfoSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[BillCode]"), m_BillCode);
	RFX_Text(pFX, _T("[HandCode]"), m_HandCode);
	RFX_Date(pFX, _T("[StartTime]"), m_StartTime);
	RFX_Date(pFX, _T("[EndTime]"), m_EndTime);
	RFX_Text(pFX, _T("[Sum]"), m_Sum);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBillCheckoutInfoSet diagnostics

#ifdef _DEBUG
void CBillCheckoutInfoSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CBillCheckoutInfoSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG


/////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
// CDestineRoomSet

IMPLEMENT_DYNAMIC(CDestineRoomSet, CRecordset)

CDestineRoomSet::CDestineRoomSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CDestineRoomSet)
	m_BillCode = _T("");
	m_Certificate = _T("");
	m_CeritifyCode = _T("");
	m_DestinerName = _T("");
	m_DestinerSex = _T("");
	m_DestineMoney = _T("");
	m_DestineTime = _T("");
	m_DestineEndTime = _T("");
	m_DestineRoomCode = _T("");
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CDestineRoomSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=酒店管理系统");
}

CString CDestineRoomSet::GetDefaultSQL()
{
	return _T("[RoomDestine]");
}

void CDestineRoomSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CDestineRoomSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[BillCode]"), m_BillCode);
	RFX_Text(pFX, _T("[Certificate]"), m_Certificate);
	RFX_Text(pFX, _T("[CeritifyCode]"), m_CeritifyCode);
	RFX_Text(pFX, _T("[DestinerName]"), m_DestinerName);
	RFX_Text(pFX, _T("[DestinerSex]"), m_DestinerSex);
	RFX_Text(pFX, _T("[DestineMoney]"), m_DestineMoney);
	RFX_Text(pFX, _T("[DestineTime]"), m_DestineTime);
	RFX_Text(pFX, _T("[DestineEndTime]"), m_DestineEndTime);
	RFX_Text(pFX, _T("[DestineRoomCode]"), m_DestineRoomCode);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CDestineRoomSet diagnostics

#ifdef _DEBUG
void CDestineRoomSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CDestineRoomSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG